## # A tibble: 154 x 5
## school `University Hospita… `VA Hospital` `Other Hospital` total
## <chr> <dbl> <dbl> <dbl> <dbl>
## 1 NYU-Grossman 1243479071 12934726 350379199 1.61e9
## 2 Baylor 0 3843131 1031370360 1.04e9
## 3 Miami-Miller 611408431 30077231 194630628 8.36e8
## 4 Pittsburgh 0 31257889 748625546 7.80e8
## 5 U Washington 396957237 98553175 202398902 6.98e8
## 6 Pennsylvania-Pe… 649176108 28072130 0 6.77e8
## 7 Mount Sinai-Ica… 0 0 667522750 6.68e8
## 8 Indiana 0 13967498 626197531 6.40e8
## 9 Johns Hopkins 0 0 540726598 5.41e8
## 10 Emory 136599359 96568079 304491560 5.38e8
## # … with 144 more rows
## # A tibble: 8 x 4
## school pre_clinical clinical total
## <chr> <dbl> <dbl> <dbl>
## 1 Harvard 351 9047 9398
## 2 Michigan 315 2445 2760
## 3 Columbia-Vagelos 268 1896 2164
## 4 Duke 242 2176 2418
## 5 Johns Hopkins 232 2719 2951
## 6 Vanderbilt 193 2514 2707
## 7 Washington U St Louis 158 1951 2109
## 8 Stanford 153 893 1046
## # A tibble: 8 x 12
## school total_funding recorded_percent unrecorded_perc… recorded_dollars
## <chr> <dbl> <dbl> <dbl> <dbl>
## 1 Johns Hopkins 479925893 100 0 479925893
## 2 Washington U… 411987189 100 0 411987189
## 3 Stanford 515682458 96.3 3.7 496661786
## 4 Michigan 418636432 92.5 7.5 387336580
## 5 Duke 549489673 91 9 499805045
## 6 Columbia-Vag… 502354997 82.2 17.8 413158755
## 7 Vanderbilt 388672389 16.9 83.1 65853856
## 8 Harvard 1679349962 13 87 218960886
## # … with 7 more variables: unrecorded_dollars <dbl>, pre_clinical <dbl>,
## # clinical <dbl>, total_faculty <dbl>, funding_per_all <dbl>,
## # recorded_per_pre <dbl>, unrecorded_per_clin <dbl>